<!DOCTYPE html>



  


<html class="theme-next pisces use-motion" lang="zh-CN">
<head>
  <meta charset="UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/>
<meta name="theme-color" content="#222">









<meta http-equiv="Cache-Control" content="no-transform" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
















  
  
  <link href="/lib/fancybox/source/jquery.fancybox.css?v=2.1.5" rel="stylesheet" type="text/css" />







<link href="/lib/font-awesome/css/font-awesome.min.css?v=4.6.2" rel="stylesheet" type="text/css" />

<link href="/css/main.css?v=5.1.4" rel="stylesheet" type="text/css" />


  <link rel="apple-touch-icon" sizes="180x180" href="/images/apple-touch-icon-next.png?v=5.1.4">


  <link rel="icon" type="image/png" sizes="32x32" href="/images/favicon-32x32-next.png?v=5.1.4">


  <link rel="icon" type="image/png" sizes="16x16" href="/images/favicon-16x16-next.png?v=5.1.4">


  <link rel="mask-icon" href="/images/logo.svg?v=5.1.4" color="#222">





  <meta name="keywords" content="Hexo, NexT" />










<meta property="og:type" content="website">
<meta property="og:title" content="落叶砸地">
<meta property="og:url" content="https://luoyezadi.gitee.io/page/2/index.html">
<meta property="og:site_name" content="落叶砸地">
<meta property="og:locale" content="zh_CN">
<meta property="article:author" content="LZH">
<meta name="twitter:card" content="summary">



<script type="text/javascript" id="hexo.configurations">
  var NexT = window.NexT || {};
  var CONFIG = {
    root: '',
    scheme: 'Pisces',
    version: '5.1.4',
    sidebar: {"position":"left","display":"post","offset":12,"b2t":false,"scrollpercent":false,"onmobile":false},
    fancybox: true,
    tabs: true,
    motion: {"enable":true,"async":false,"transition":{"post_block":"fadeIn","post_header":"slideDownIn","post_body":"slideDownIn","coll_header":"slideLeftIn","sidebar":"slideUpIn"}},
    duoshuo: {
      userId: '0',
      author: 'Author'
    },
    algolia: {
      applicationID: '',
      apiKey: '',
      indexName: '',
      hits: {"per_page":10},
      labels: {"input_placeholder":"Search for Posts","hits_empty":"We didn't find any results for the search: ${query}","hits_stats":"${hits} results found in ${time} ms"}
    }
  };
</script>



  <link rel="canonical" href="https://luoyezadi.gitee.io/page/2/"/>





  <title>落叶砸地</title>
  








<meta name="generator" content="Hexo 5.4.2"></head>

<body itemscope itemtype="http://schema.org/WebPage" lang="zh-CN">

  
  
    
  

  <div class="container sidebar-position-left 
  page-home">
    <div class="headband"></div>

    <header id="header" class="header" itemscope itemtype="http://schema.org/WPHeader">
      <div class="header-inner"><div class="site-brand-wrapper">
  <div class="site-meta ">
    

    <div class="custom-logo-site-title">
      <a href="/"  class="brand" rel="start">
        <span class="logo-line-before"><i></i></span>
        <span class="site-title">落叶砸地</span>
        <span class="logo-line-after"><i></i></span>
      </a>
    </div>
      
        <p class="site-subtitle">java,web,树莓派,花生壳</p>
      
  </div>

  <div class="site-nav-toggle">
    <button>
      <span class="btn-bar"></span>
      <span class="btn-bar"></span>
      <span class="btn-bar"></span>
    </button>
  </div>
</div>

<nav class="site-nav">
  

  
    <ul id="menu" class="menu">
      
        
        <li class="menu-item menu-item-home">
          <a href="/%20" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-home"></i> <br />
            
            Home
          </a>
        </li>
      
        
        <li class="menu-item menu-item-archives">
          <a href="/archives/%20" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-archive"></i> <br />
            
            Archives
          </a>
        </li>
      

      
    </ul>
  

  
</nav>



 </div>
    </header>

    <main id="main" class="main">
      <div class="main-inner">
        <div class="content-wrap">
          <div id="content" class="content">
            
  <section id="posts" class="posts-expand">
    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/%E5%A5%BD%E7%94%A8%E7%9A%84%E7%AE%97%E6%B3%95%E6%BC%94%E7%A4%BA%E7%BD%91%E7%AB%99/2019/06/21/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/%E5%A5%BD%E7%94%A8%E7%9A%84%E7%AE%97%E6%B3%95%E6%BC%94%E7%A4%BA%E7%BD%91%E7%AB%99/2019/06/21/" itemprop="url">好用的算法演示网站</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-06-21T21:42:00+08:00">
                2019-06-21
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p><a target="_blank" rel="noopener" href="https://www.cs.usfca.edu/~galles/visualization/AVLtree.html">算法演示</a></p>
<p><a target="_blank" rel="noopener" href="https://github.com/imhuay/Algorithm_Interview_Notes-Chinese">算法学习</a></p>
<p><a target="_blank" rel="noopener" href="https://leetcode-cn.com/problemset/algorithms/">算法刷题</a></p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/%E6%88%91%E6%98%AF%E4%B8%80%E4%B8%AAHTTP%E8%AF%B7%E6%B1%82/2019/05/29/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/%E6%88%91%E6%98%AF%E4%B8%80%E4%B8%AAHTTP%E8%AF%B7%E6%B1%82/2019/05/29/" itemprop="url">我是一个HTTP请求</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-05-29T11:27:00+08:00">
                2019-05-29
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p>自己理解的，不对请指出<br>    我是由一个应用控制电脑某个端口发送出来的，当我走出电脑的时候我要记住谁把我扔出来的（端口），也要知道我的目的地（IP或者URL）和目标端口，当我走出来后发现，这个世界太大了。我只在一个小村子里（局域网），我现在身上只有怀揣的秘密（HTTP数据），自身端口和目标IP及目标端口。我先在村子里喊（广播）：“有谁知道我的目标IP吗？”<br>-1.有人回应：我就通过ARP得到他的身份ID（MAC）直接发给他<br>-2.没人回应：那我就可怜了，就需要去问知识渊博的村长(路由器)了。<br>    村长那里有一个神奇的小本子记着几乎整个世界的信息（路由表），村长从本子上一看，帮我找到了一条最近的路线，让我带着干粮上路，此时村长根据NAT技术帮我标记了个回来的路（路由器一个端口指到我电脑，用来区分子网内不同机器），村长也根据ARP打听到了下一个村子的MAC，我就顺着网线直接过去了。此时我身上有了更多的信息了：HTTP新数据，目标IP及其端口，本地路由IP及其分配的端口，自身应用程序端口。我中间经过了很多村子（不断地路由），这段跟修真小说似的，每上一级就发现自己很菜需要路由各种转（每次看成重新开始）。<br>    我就带着这些信息一路走啊走啊。终于到了目标IP。然后我告诉这个村的村长，我找目标端口，村长带着我把我一路艰辛带过来的秘密（HTTP数据）和我的地址（本地路由IP及其分配的端口）告诉了目标端口，让他完事了记得告诉交代我任务的应用程序。到此我的就完成了我的使命！！</p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/decompiler/2019/05/08/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/decompiler/2019/05/08/" itemprop="url">很好用的Eclipse插件</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-05-08T17:16:00+08:00">
                2019-05-08
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <h1 id="1-decompiler"><a href="#1-decompiler" class="headerlink" title="1.decompiler"></a>1.decompiler</h1><p>查看源码用的</p>
<h1 id="2-Bytecode-Outline"><a href="#2-Bytecode-Outline" class="headerlink" title="2.Bytecode Outline"></a>2.Bytecode Outline</h1><p><a target="_blank" rel="noopener" href="https://blog.csdn.net/linbilin_/article/details/60959461">https://blog.csdn.net/linbilin_/article/details/60959461</a><br>Eclipse安装查看java字节码插件</p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/oracle%E5%AF%BC%E5%85%A5dmp%E6%96%87%E4%BB%B6-%E6%9B%BF%E6%8D%A2%E7%8E%B0%E6%9C%89%E8%A1%A8/2019/04/25/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/oracle%E5%AF%BC%E5%85%A5dmp%E6%96%87%E4%BB%B6-%E6%9B%BF%E6%8D%A2%E7%8E%B0%E6%9C%89%E8%A1%A8/2019/04/25/" itemprop="url">oracle导入dmp文件 替换现有表</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-25T08:06:00+08:00">
                2019-04-25
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <h1 id="当使用IMPDP完成数据库导入时，如遇到表已存在时，Oracle提供给我们如下四种处理方式："><a href="#当使用IMPDP完成数据库导入时，如遇到表已存在时，Oracle提供给我们如下四种处理方式：" class="headerlink" title="当使用IMPDP完成数据库导入时，如遇到表已存在时，Oracle提供给我们如下四种处理方式："></a>当使用IMPDP完成数据库导入时，如遇到表已存在时，Oracle提供给我们如下四种处理方式：</h1><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br></pre></td><td class="code"><pre><span class="line">a.忽略（SKIP，默认行为）；</span><br><span class="line">b.在原有数据基础上继续增加（APPEND）；</span><br><span class="line">c.先DROP表，然后创建表，最后完成数据插入（REPLACE）；</span><br><span class="line">d.先TRUNCATE，再完成数据插入（TRUNCATE）。</span><br><span class="line"></span><br><span class="line">先用EXPDP生成一份dump文件</span><br><span class="line">sec@secDB /expdp$ expdp sec/sec directory=expdp_dir dumpfile=`date +&quot;%Y%m%d%H%M%S&quot;`_sec.dmp logfile=`date +&quot;%Y%m%d%H%M%S&quot;`_sec.log</span><br><span class="line"></span><br><span class="line">分别使用四中方式真实的感知一下具体效果</span><br><span class="line">用到的IMPDP语句统一汇总在这里，方便参考。</span><br><span class="line">SKIP：</span><br><span class="line">impdp system/sys directory=expdp_dir dumpfile=20100401102917_sec.dmp logfile=20100401102917_sec_impdp.log TABLE_EXISTS_ACTION=SKIP</span><br><span class="line"></span><br><span class="line">APPEND：</span><br><span class="line">impdp system/sys directory=expdp_dir dumpfile=20100401102917_sec.dmp logfile=20100401102917_sec_impdp.log TABLE_EXISTS_ACTION=APPEND</span><br><span class="line"></span><br><span class="line">REPLACE：</span><br><span class="line">impdp system/sys directory=expdp_dir dumpfile=20100401102917_sec.dmp logfile=20100401102917_sec_impdp.log TABLE_EXISTS_ACTION=REPLACE</span><br><span class="line"></span><br><span class="line">TRUNCATE：</span><br><span class="line">impdp system/sys directory=expdp_dir dumpfile=20100401102917_sec.dmp logfile=20100401102917_sec_impdp.log TABLE_EXISTS_ACTION=TRUNCATE</span><br></pre></td></tr></table></figure>
<p> impdp user/password@pdborcl FROMUSER=ICM_DEV TOUSER=user directory=TEST dumpfile=XXXXXXXXXXXXXXXX.dmp logfile=X.log table_exists_action=truncate</p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/WebSSH2%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B/2019/04/23/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/WebSSH2%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B/2019/04/23/" itemprop="url">WebSSH2安装教程</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-23T02:48:00+08:00">
                2019-04-23
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p>github源码<a target="_blank" rel="noopener" href="https://github.com/billchurch/WebSSH2">https://github.com/billchurch/WebSSH2</a></p>
<h1 id="以下所有npm可以使用cnpm（淘宝源）没试过"><a href="#以下所有npm可以使用cnpm（淘宝源）没试过" class="headerlink" title="以下所有npm可以使用cnpm（淘宝源）没试过"></a>以下所有npm可以使用cnpm（淘宝源）没试过</h1><h1 id="1-安装git-npm-Node-js"><a href="#1-安装git-npm-Node-js" class="headerlink" title="1.安装git npm Node.js"></a>1.安装git npm Node.js</h1><h1 id="2-clon"><a href="#2-clon" class="headerlink" title="2.clon"></a>2.clon</h1><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line">git clone https://github.com/billchurch/WebSSH2</span><br><span class="line">cd WebSSH2</span><br><span class="line">cp app/package.json package.json</span><br><span class="line">nano package.json</span><br><span class="line">--!!!!!!!!!此处修改start对应的index.js前加上app/</span><br><span class="line">npm init</span><br><span class="line">npm install --production</span><br></pre></td></tr></table></figure>

<h2 id="上面之前一直缺少package-json，后来发现被放到了app路径下，要哭了！！！"><a href="#上面之前一直缺少package-json，后来发现被放到了app路径下，要哭了！！！" class="headerlink" title="上面之前一直缺少package.json，后来发现被放到了app路径下，要哭了！！！"></a>上面之前一直缺少package.json，后来发现被放到了app路径下，要哭了！！！</h2><h1 id="3-开一个远程画面"><a href="#3-开一个远程画面" class="headerlink" title="3.开一个远程画面"></a>3.开一个远程画面</h1><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">cd WebSSH2</span><br><span class="line">npm start</span><br></pre></td></tr></table></figure>
          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/%E5%8E%9F%E7%A0%81%EF%BC%8C%E5%8F%8D%E7%A0%81%EF%BC%8C%E8%A1%A5%E7%A0%81%E5%8E%9F%E6%9D%A5%E5%8F%AF%E4%BB%A5%E8%BF%99%E6%A0%B7%E5%8E%BB%E7%90%86%E8%A7%A3%EF%BC%81%EF%BC%81/2019/04/20/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/%E5%8E%9F%E7%A0%81%EF%BC%8C%E5%8F%8D%E7%A0%81%EF%BC%8C%E8%A1%A5%E7%A0%81%E5%8E%9F%E6%9D%A5%E5%8F%AF%E4%BB%A5%E8%BF%99%E6%A0%B7%E5%8E%BB%E7%90%86%E8%A7%A3%EF%BC%81%EF%BC%81/2019/04/20/" itemprop="url">原码，反码，补码原来可以这样去理解！！</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-20T19:24:00+08:00">
                2019-04-20
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p>画出那个连贯图<br>挺好<br><a target="_blank" rel="noopener" href="https://zhuanlan.zhihu.com/p/36036038">https://zhuanlan.zhihu.com/p/36036038</a></p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/Oracle%E4%B8%AD%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B0/2019/04/20/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/Oracle%E4%B8%AD%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B0/2019/04/20/" itemprop="url">Oracle中常用函数</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-20T19:18:00+08:00">
                2019-04-20
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p><a target="_blank" rel="noopener" href="https://www.cnblogs.com/lxl57610/p/7442130.html">https://www.cnblogs.com/lxl57610/p/7442130.html</a></p>
<h1 id="一、字符函数"><a href="#一、字符函数" class="headerlink" title="一、字符函数"></a>一、字符函数</h1><p> 字符函数接受字符参数，这些参数可以是表中的列，也可以是一个字符串表达式。<br><img src="/images/pasted-1.png" alt="upload successful"><br>函数    说明<br>ASCII(X)    返回字符X的ASCII码<br>CONCAT(X,Y)    连接字符串X和Y<br>INSTR(X,STR[,START][,N)    从X中查找str，可以指定从start开始，也可以指定从n开始<br>LENGTH(X)    返回X的长度<br>LOWER(X)    X转换成小写<br>UPPER(X)    X转换成大写<br>LTRIM(X[,TRIM_STR])    把X的左边截去trim_str字符串，缺省截去空格<br>RTRIM(X[,TRIM_STR])    把X的右边截去trim_str字符串，缺省截去空格<br>TRIM([TRIM_STR  FROM]X)    把X的两边截去trim_str字符串，缺省截去空格<br>REPLACE(X,old,new)    在X中查找old，并替换成new<br>SUBSTR(X,start[,length])    返回X的字串，从start处开始，截取length个字符，缺省length，默认到结尾</p>
<p><img src="/images/20190506Oracle%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B0%E6%BC%94%E7%A4%BA.png" alt="upload successful"><br>示例    示例结果<br>SELECT ASCII(‘a’) FROM dual;    97<br>SELECT CONCAT(‘Hello’,’world’) FROM dual;    Helloworld<br>SELECT INSTR(‘Hello world’,’or’) FROM dual;    8<br>SELECT LENGTH(‘Hello’) FROM dual;    5<br>SELECT LOWER(‘Hello’) FROM dual;    hello<br>SELECT UPPER(‘hello’) FROM dual;    HELLO<br>SELECT LTRIM(‘=Hello=’,’=’) FROM dual;    Hello=<br>SELECT RTRIM(‘=Hello=’,’=’) FROM dual;    =Hello<br>SELECT TRIM(‘=’FROM’=Hello=’) FROM dual;    Hello<br>SELECT REPLACE(‘ABCDE’,’CD’,’AAA’)FROM dual;    ABAAAE<br>SELECT SUBSTR(‘ABCDE’,2,3) FROM dual;    BCD</p>
<h1 id="二、数字函数"><a href="#二、数字函数" class="headerlink" title="二、数字函数"></a>二、数字函数</h1><p>数字函数接受数字参数，参数可以来自表中的一列，也可以是一个数字表达式。<br>函数    说明    示例<br>ABS(X)    X的绝对值    ABS(-3)=3<br>ACOS(X)    X的反余弦    ACOS(1)=0<br>COS(X)    余弦    COS(1)=0.54030230586814<br>CEIL(X)    大于或等于X的最小值    CEIL(5.4)=6<br>FLOOR(X)    小于或等于X的最大值    FLOOR(5.8)=5<br>LOG(X,Y)    X为底Y的对数    LOG(2，4)=2<br>MOD(X,Y)    X除以Y的余数    MOD(8，3)=2<br>POWER(X,Y)    X的Y次幂    POWER(2，3)=8<br>ROUND(X[,Y])    X在第Y位四舍五入    ROUND(3.456，2)=3.46<br>SQRT(X)    X的平方根    SQRT(4)=2<br>TRUNC(X[,Y])    X在第Y位截断    TRUNC(3.456，2)=3.45</p>
<p><img src="/images/20190506%E6%95%B0%E5%AD%97%E5%87%BD%E6%95%B0%E6%BC%94%E7%A4%BA.png" alt="upload successful"></p>
<h1 id="三、日期函数"><a href="#三、日期函数" class="headerlink" title="三、日期函数"></a>三、日期函数</h1>
          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/%E6%B5%85%E6%8E%A2%E5%A4%9A%E7%BA%BF%E7%A8%8B%E5%92%8C%E5%88%86%E5%B8%83%E5%BC%8F/2019/04/20/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/%E6%B5%85%E6%8E%A2%E5%A4%9A%E7%BA%BF%E7%A8%8B%E5%92%8C%E5%88%86%E5%B8%83%E5%BC%8F/2019/04/20/" itemprop="url">浅探多线程和分布式</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-20T19:17:00+08:00">
                2019-04-20
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p>先查资料吧<br>。。。。</p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/%E8%AE%BE%E8%AE%A1%E6%A8%A1%E5%BC%8F/2019/04/20/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/%E8%AE%BE%E8%AE%A1%E6%A8%A1%E5%BC%8F/2019/04/20/" itemprop="url">设计模式</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-20T19:15:00+08:00">
                2019-04-20
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p>23种设计模式</p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
      

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="https://luoyezadi.gitee.io/%E6%9C%80%E5%88%9D/%E7%AE%97%E6%B3%95%E6%A6%82%E8%BF%B0/2019/04/20/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="落叶砸地">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
                
                <a class="post-title-link" href="/%E6%9C%80%E5%88%9D/%E7%AE%97%E6%B3%95%E6%A6%82%E8%BF%B0/2019/04/20/" itemprop="url">算法概述</a></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">Posted on</span>
              
              <time title="Post created" itemprop="dateCreated datePublished" datetime="2019-04-20T19:14:00+08:00">
                2019-04-20
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        
          
            <p>拿那本书去看看<br>时间空间复杂度</p>

          
        
      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      

      

      
      
        <div class="post-eof"></div>
      
    </footer>
  </div>
  
  
  
  </article>


    
  </section>

  
  <nav class="pagination">
    <a class="extend prev" rel="prev" href="/">&lt;i class&#x3D;&quot;fa fa-angle-left&quot;&gt;&lt;&#x2F;i&gt;</a><a class="page-number" href="/">1</a><span class="page-number current">2</span><a class="page-number" href="/page/3/">3</a><a class="page-number" href="/page/4/">4</a><a class="extend next" rel="next" href="/page/3/">&lt;i class&#x3D;&quot;fa fa-angle-right&quot;&gt;&lt;&#x2F;i&gt;</a>
  </nav>



          </div>
          


          

        </div>
        
          
  
  <div class="sidebar-toggle">
    <div class="sidebar-toggle-line-wrap">
      <span class="sidebar-toggle-line sidebar-toggle-line-first"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-middle"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-last"></span>
    </div>
  </div>

  <aside id="sidebar" class="sidebar">
    
    <div class="sidebar-inner">

      

      

      <section class="site-overview-wrap sidebar-panel sidebar-panel-active">
        <div class="site-overview">
          <div class="site-author motion-element" itemprop="author" itemscope itemtype="http://schema.org/Person">
            
              <p class="site-author-name" itemprop="name"></p>
              <p class="site-description motion-element" itemprop="description"></p>
          </div>

          <nav class="site-state motion-element">

            
              <div class="site-state-item site-state-posts">
              
                <a href="/archives/%20%7C%7C%20archive">
              
                  <span class="site-state-item-count">37</span>
                  <span class="site-state-item-name">posts</span>
                </a>
              </div>
            

            
              
              
              <div class="site-state-item site-state-categories">
                
                  <span class="site-state-item-count">8</span>
                  <span class="site-state-item-name">categories</span>
                
              </div>
            

            
              
              
              <div class="site-state-item site-state-tags">
                
                  <span class="site-state-item-count">43</span>
                  <span class="site-state-item-name">tags</span>
                
              </div>
            

          </nav>

          

          

          
          

          
          

          

        </div>
      </section>

      

      

    </div>
  </aside>


        
      </div>
    </main>

    <footer id="footer" class="footer">
      <div class="footer-inner">
        <div class="copyright">&copy; <span itemprop="copyrightYear">2023</span>
  <span class="with-love">
    <i class="fa fa-user"></i>
  </span>
  <span class="author" itemprop="copyrightHolder">LZH</span>

  
</div>


  <div class="powered-by">Powered by <a class="theme-link" target="_blank" href="https://hexo.io">Hexo</a></div>



  <span class="post-meta-divider">|</span>



  <div class="theme-info">Theme &mdash; <a class="theme-link" target="_blank" href="https://github.com/iissnan/hexo-theme-next">NexT.Pisces</a> v5.1.4</div>




        







        
      </div>
    </footer>

    
      <div class="back-to-top">
        <i class="fa fa-arrow-up"></i>
        
      </div>
    

    

  </div>

  

<script type="text/javascript">
  if (Object.prototype.toString.call(window.Promise) !== '[object Function]') {
    window.Promise = null;
  }
</script>









  












  
  
    <script type="text/javascript" src="/lib/jquery/index.js?v=2.1.3"></script>
  

  
  
    <script type="text/javascript" src="/lib/fastclick/lib/fastclick.min.js?v=1.0.6"></script>
  

  
  
    <script type="text/javascript" src="/lib/jquery_lazyload/jquery.lazyload.js?v=1.9.7"></script>
  

  
  
    <script type="text/javascript" src="/lib/velocity/velocity.min.js?v=1.2.1"></script>
  

  
  
    <script type="text/javascript" src="/lib/velocity/velocity.ui.min.js?v=1.2.1"></script>
  

  
  
    <script type="text/javascript" src="/lib/fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>
  


  


  <script type="text/javascript" src="/js/src/utils.js?v=5.1.4"></script>

  <script type="text/javascript" src="/js/src/motion.js?v=5.1.4"></script>



  
  


  <script type="text/javascript" src="/js/src/affix.js?v=5.1.4"></script>

  <script type="text/javascript" src="/js/src/schemes/pisces.js?v=5.1.4"></script>



  

  


  <script type="text/javascript" src="/js/src/bootstrap.js?v=5.1.4"></script>



  


  




	





  





  












  





  

  

  

  
  

  

  

  

</body>
</html>
